Release 10.1A: OpenEdge Development:
ADM Reference

sendRows

Procedure that fetches the requested number of rows from the database Query and creates corresponding records in the Row Object temp-table. The batch typically starts at the row indicated by the pcRowIdent parameter, however, it can start on the row indicated by the piStartRow parameter.

Location: data.p

Parameters:

INPUT piStartRow AS INTEGER

The RowNum to start on. An undefined value (?) indicates that the next argument (pcRowIdent) determines the start of the batch to be returned.

INPUT pcRowIdent AS CHARACTER

An alternative to StartRow. It is either FIRST, LAST, or a comma-delimited list of database ROWIDs. If it is FIRST or LAST, the first or last batch of records in the result set is retrieved and piStartRow is forced to ?. If it is a comma-delimited list of database ROWIDs, the batch starts with a RowObject that comprises those records.

INPUT plNext AS LOGICAL

TRUE if the query should perform NEXT/PREV (depending on the direction of navigation) before starting to return more rows. In other words, SKIP to the next record at the start of the batch.

INPUT piRowsToReturn AS INTEGER

The maximum number of rows to return (supply a negative value to move backwards in the result set).

OUTPUT piRowsReturned AS INTEGER

The actual number of rows returned.

Notes: Before returning, sendRows repositions the RowObject query to what was the current row when it started. The pcRowIdent argument is used by fetchRowIdent to allow query repositioning to a specific database query row.